prepare("insert into invent_transfer(transfer_date,releasing_dept,receiving_dept,item_category,item_name,measure,qty,admin) values(:a,:b,:c,:d,:e,:f,:g,:h)") ;
$query->bindparam(":a",$_SESSION['rdate']) ;
$query->bindparam(":b",$_SESSION['dept']) ;
$query->bindparam(":c",$_SESSION['rdept']) ;
$query->bindparam(":d",$cat) ;
$query->bindparam(":e",$iname) ;
$query->bindparam(":f",$ms) ;
$query->bindparam(":g",$qty) ;
$query->bindparam(":h",$adm) ;
$query->execute() ;
}
if(isset($_POST['commit']))
{
$ivid = transferid() ;
$chk = $DBcon->prepare("select * from invent_transfer") ;
$chk->execute() ;
if($chk->rowcount() > 0)
{
//$gettcost = $DBcon->prepare("select sum(totalcost) as tcost from invent_temporal") ;
//$gettcost->execute() ;
//$rwd = $gettcost->fetch(pdo::FETCH_ASSOC) ;
//$gc = $rwd['tcost'] ;
$ins = $DBcon->prepare("insert into transfer_main(tranfer_date,transfer_id,release_dept,receiving_dept,admin) values(:a,:b,:c,:d,:e)") ;
$ins->bindparam(":a",$_SESSION['rdate']) ;
$ins->bindparam(":b",$ivid) ;
$ins->bindparam(":c",$_SESSION['dept']) ;
$ins->bindparam(":d",$_SESSION['rdept']) ;
$ins->bindparam(":e",$adm) ;
if($ins->execute())
{
$getall = $DBcon->prepare("select * from invent_transfer") ;
$getall->execute() ;
while($rd = $getall->fetch(pdo::FETCH_ASSOC))
{
$comit = $DBcon->prepare("insert into transfer_details(transfer_id,item_category,item_name,measure,qty)values(:a,:b,:c,:d,:e)") ;
$comit->bindparam(":a",$ivid) ;
$comit->bindparam(":b",$rd['item_category']) ;
$comit->bindparam(":c",$rd['item_name']) ;
$comit->bindparam(":e",$rd['qty']) ;
$comit->bindparam(":d",$rd['measure']) ;
if($comit->execute())
{
$del = $DBcon->prepare("delete from invent_transfer") ;
if($del->execute()) $mos = "RECORD COMMITED SUCCESSFUL TO DATABASE" ;
}
}
}
}
else
{
$mos = "NO RECORDS TO MOVE" ;
}
}
?>
Demanding Items